DROP VIEW RA$Objects;

DROP SEQUENCE RA$ObjectID_Seq;

ALTER TABLE RA$Pages
ADD retentionUnit VARCHAR2(8);

ALTER TABLE RA$Pages
ADD retentionMeasure NUMBER(3);

ALTER TABLE RA$Pages
ADD CONSTRAINT pages_retentionUnit_ck CHECK (retentionUnit IN ('Versions','Years','Months','Days','Forever'));

DROP TABLE RA$RetentionSettings CASCADE CONSTRAINTS PURGE;

ALTER TABLE RA$Folders DROP COLUMN retentionID;
ALTER TABLE RA$Pages DROP COLUMN retentionID;

DROP SEQUENCE RA$SettingsID_Seq;